/*
 Navicat Premium Data Transfer

 Source Server         : 139.159.220.137bthlt
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : 139.159.220.137
 Source Database       : work

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : utf-8

 Date: 04/01/2017 10:59:41 AM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `auth_group`
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `auth_group_permissions`
-- ----------------------------
DROP TABLE IF EXISTS `auth_group_permissions`;
CREATE TABLE `auth_group_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_group_permissions_group_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  KEY `auth_group_permissi_permission_id_84c5c92e_fk_auth_permission_id` (`permission_id`),
  CONSTRAINT `auth_group_permissi_permission_id_84c5c92e_fk_auth_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `auth_permission`
-- ----------------------------
DROP TABLE IF EXISTS `auth_permission`;
CREATE TABLE `auth_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `content_type_id` int(11) NOT NULL,
  `codename` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_permission_content_type_id_01ab375a_uniq` (`content_type_id`,`codename`),
  CONSTRAINT `auth_permissi_content_type_id_2f476e4b_fk_django_content_type_id` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `auth_permission`
-- ----------------------------
BEGIN;
INSERT INTO `auth_permission` VALUES ('1', 'Can add log entry', '1', 'add_logentry'), ('2', 'Can change log entry', '1', 'change_logentry'), ('3', 'Can delete log entry', '1', 'delete_logentry'), ('4', 'Can add permission', '2', 'add_permission'), ('5', 'Can change permission', '2', 'change_permission'), ('6', 'Can delete permission', '2', 'delete_permission'), ('7', 'Can add user', '3', 'add_user'), ('8', 'Can change user', '3', 'change_user'), ('9', 'Can delete user', '3', 'delete_user'), ('10', 'Can add group', '4', 'add_group'), ('11', 'Can change group', '4', 'change_group'), ('12', 'Can delete group', '4', 'delete_group'), ('13', 'Can add content type', '5', 'add_contenttype'), ('14', 'Can change content type', '5', 'change_contenttype'), ('15', 'Can delete content type', '5', 'delete_contenttype'), ('16', 'Can add session', '6', 'add_session'), ('17', 'Can change session', '6', 'change_session'), ('18', 'Can delete session', '6', 'delete_session'), ('19', 'Can add 购物中心', '7', 'add_shop'), ('20', 'Can change 购物中心', '7', 'change_shop'), ('21', 'Can delete 购物中心', '7', 'delete_shop'), ('25', 'Can add 故障模板', '9', 'add_error'), ('26', 'Can change 故障模板', '9', 'change_error'), ('27', 'Can delete 故障模板', '9', 'delete_error'), ('28', 'Can add 系统模板', '10', 'add_system'), ('29', 'Can change 系统模板', '10', 'change_system'), ('30', 'Can delete 系统模板', '10', 'delete_system'), ('31', 'Can add 记录值', '11', 'add_record'), ('32', 'Can change 记录值', '11', 'change_record'), ('33', 'Can delete 记录值', '11', 'delete_record'), ('34', 'Can add 配置项目', '12', 'add_config'), ('35', 'Can change 配置项目', '12', 'change_config'), ('36', 'Can delete 配置项目', '12', 'delete_config'), ('37', 'Can add 记录值', '13', 'add_workrecord'), ('38', 'Can change 记录值', '13', 'change_workrecord'), ('39', 'Can delete 记录值', '13', 'delete_workrecord');
COMMIT;

-- ----------------------------
--  Table structure for `auth_user`
-- ----------------------------
DROP TABLE IF EXISTS `auth_user`;
CREATE TABLE `auth_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `password` varchar(128) NOT NULL,
  `last_login` datetime(6) DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(150) NOT NULL,
  `first_name` varchar(30) NOT NULL,
  `last_name` varchar(30) NOT NULL,
  `email` varchar(254) NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `auth_user`
-- ----------------------------
BEGIN;
INSERT INTO `auth_user` VALUES ('1', 'pbkdf2_sha256$30000$9p2ohLH6hI9R$AQcZpqudXy/Kz7+QwHg79DTmzpCDpfpGVcr5zxeQf5Y=', '2017-03-31 13:28:20.116703', '1', 'admin', '', '', '', '1', '1', '2017-03-28 04:22:47.686711'), ('2', 'pbkdf2_sha256$30000$yUi4vfSg7ADC$Y6EfCr4AVHKOhiO4R3Bq4fbBk23XbleKWXyACEf7OYE=', '2017-04-01 02:58:35.123871', '0', 'liunabin', '', '', '', '0', '1', '2017-03-28 08:01:51.910540'), ('4', 'pbkdf2_sha256$30000$RG4GTpBdWJfZ$JSOhDjnqd4CsLmngLd7dvm+U9KKrjdo+IMpncjqHMTA=', '2017-03-31 13:28:26.807239', '0', 'chenting', '', '', '', '0', '1', '2017-03-31 13:07:00.000000'), ('5', 'pbkdf2_sha256$30000$Y7RYEsH9Gv6t$vefh3OiD7WIcUIpTVQMeVlWYYlPUq66RZtDnQ0Y4yMw=', null, '0', 'linyuan', '', '', '', '0', '1', '2017-03-31 13:07:47.189935'), ('6', 'pbkdf2_sha256$30000$JAfBR5maYpse$90Vuul9efChGTwW6FymqLwKCTxDrCv4AzIDp0e6VHsk=', null, '0', 'dengwenxian', '', '', '', '0', '1', '2017-03-31 13:08:00.775378'), ('7', 'pbkdf2_sha256$30000$sUzcBdwN6l8y$NqgswSXRTFqOeSHd01tjrwwuUnbcPYyNmHmnHNfcp4A=', null, '0', 'zhudong', '', '', '', '0', '1', '2017-03-31 13:08:34.555928'), ('8', 'pbkdf2_sha256$30000$A41mByaNSQWr$mSdIe82YcldhlNVI1MJr6TgPzxlBzAfWU7MG40tda50=', null, '0', 'wufujing', '', '', '', '0', '1', '2017-03-31 13:09:01.116638'), ('9', 'pbkdf2_sha256$30000$tdXdwSmHbymU$v/OIYot4XrePVGV2GskLsAyXon6hvm0oafxwGt5wR1M=', null, '0', 'yuanruoqing', '', '', '', '0', '1', '2017-03-31 13:09:12.883358'), ('10', 'pbkdf2_sha256$30000$3T74hRTuvd5h$gFdwY5hYzYv0K/INlvzMf8/RlBimlgulQklPBQNCugk=', null, '0', 'leixiaoming', '', '', '', '0', '1', '2017-03-31 13:09:43.242872'), ('11', 'pbkdf2_sha256$30000$0KjJTtw0CiVD$ZTnsPG+DG504GI/ruJLEKSeHir95a7bhYof9+PRinjM=', null, '0', 'zhoubinbin', '', '', '', '0', '1', '2017-03-31 13:15:47.016372'), ('12', 'pbkdf2_sha256$30000$HwwfIEZffCUh$sP/CCbQojNTcMk4RWSxexdtfG3e74yZ53URofOM2Le8=', null, '0', 'lujun', '', '', '', '0', '1', '2017-03-31 13:15:59.527165'), ('13', 'pbkdf2_sha256$30000$ceXgy3Acas5X$Imgi6dRqdV/NrL/o+lbcjMpEEb8ro3HhXuM9m4Tk8e8=', null, '0', 'caizhibin', '', '', '', '0', '1', '2017-03-31 13:26:33.226978'), ('14', 'pbkdf2_sha256$30000$QpPsjDgdlP02$Xo2qvKBzpzPsYbpIvtDHqwJUS7ZZnVYXgbCYtds4swU=', null, '0', 'zhongzhenhong', '', '', '', '0', '1', '2017-03-31 13:27:03.205161'), ('15', 'pbkdf2_sha256$30000$pquX0yom4mFZ$wic4E4HFuII0kqonyB33TkvO90KvUKJDEcf7KRui6dk=', null, '0', 'mailicheng', '', '', '', '0', '1', '2017-03-31 13:31:02.249242'), ('16', 'pbkdf2_sha256$30000$eCRSqJsydK2w$WxtcWClF9z1v/U4cNcSofvyg0rS+u6ubZCLD2SIdBtE=', '2017-03-31 14:15:44.581226', '0', 'test', '', '', '', '0', '1', '2017-03-31 14:05:29.271637');
COMMIT;

-- ----------------------------
--  Table structure for `auth_user_groups`
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_groups`;
CREATE TABLE `auth_user_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_groups_user_id_94350c0c_uniq` (`user_id`,`group_id`),
  KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`),
  CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `auth_user_user_permissions`
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_user_permissions`;
CREATE TABLE `auth_user_user_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_user_permissions_user_id_14a6b632_uniq` (`user_id`,`permission_id`),
  KEY `auth_user_user_perm_permission_id_1fbb5f2c_fk_auth_permission_id` (`permission_id`),
  CONSTRAINT `auth_user_user_perm_permission_id_1fbb5f2c_fk_auth_permission_id` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `django_admin_log`
-- ----------------------------
DROP TABLE IF EXISTS `django_admin_log`;
CREATE TABLE `django_admin_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint(5) unsigned NOT NULL,
  `change_message` longtext NOT NULL,
  `content_type_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin__content_type_id_c4bce8eb_fk_django_content_type_id` (`content_type_id`),
  KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`),
  CONSTRAINT `django_admin__content_type_id_c4bce8eb_fk_django_content_type_id` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `django_admin_log`
-- ----------------------------
BEGIN;
INSERT INTO `django_admin_log` VALUES ('1', '2017-03-28 07:57:34.698867', '1', 'cococity,liunabin', '1', '[{\"added\": {}}]', '7', '1'), ('2', '2017-03-28 07:57:56.928379', '2', 'cococity,wangzi', '1', '[{\"added\": {}}]', '7', '1'), ('3', '2017-03-28 08:00:14.139264', '1', 'work object', '1', '[{\"added\": {}}]', null, '1'), ('4', '2017-03-28 08:00:28.514059', '1', 'work object', '2', '[{\"changed\": {\"fields\": [\"errortype\"]}}]', null, '1'), ('5', '2017-03-28 08:01:52.073757', '2', 'liunabin', '1', '[{\"added\": {}}]', '3', '1'), ('6', '2017-03-28 08:03:23.437750', '3', 'wangzi', '1', '[{\"added\": {}}]', '3', '1'), ('7', '2017-03-28 08:04:00.714626', '3', 'ICO,liunabin', '1', '[{\"added\": {}}]', '7', '1'), ('8', '2017-03-28 08:21:15.856786', '1', 'work object', '2', '[]', null, '1'), ('9', '2017-03-28 08:21:27.213786', '1', 'work object', '2', '[{\"changed\": {\"fields\": [\"errortype\"]}}]', null, '1'), ('10', '2017-03-28 08:23:36.683988', '2', 'work object', '1', '[{\"added\": {}}]', null, '1'), ('11', '2017-03-28 08:25:39.788080', '2', 'POS系统', '2', '[{\"changed\": {\"fields\": [\"errortype\"]}}]', null, '1'), ('12', '2017-03-28 08:25:49.683222', '1', 'POS系统', '2', '[{\"changed\": {\"fields\": [\"time_work\"]}}]', null, '1'), ('13', '2017-03-28 08:40:20.532914', '1', 'POS系统', '1', '[{\"added\": {}}]', '10', '1'), ('14', '2017-03-28 08:41:04.502800', '1', '收银系统', '2', '[{\"changed\": {\"fields\": [\"systemname\"]}}]', '10', '1'), ('15', '2017-03-28 08:41:22.543777', '2', 'POS系统', '1', '[{\"added\": {}}]', '10', '1'), ('16', '2017-03-28 09:04:00.142794', '1', '和收银员聊天', '1', '[{\"added\": {}}]', '9', '1'), ('17', '2017-03-28 09:04:20.714046', '2', '和收银员聊天', '1', '[{\"added\": {}}]', '9', '1'), ('18', '2017-03-28 09:04:38.404363', '2', '回收POS机', '2', '[{\"changed\": {\"fields\": [\"errortype\"]}}]', '9', '1'), ('19', '2017-03-29 03:53:15.214559', '4', '1    1', '1', '[{\"added\": {}}]', '12', '1'), ('20', '2017-03-29 03:53:26.552272', '4', '1    1', '3', '', '12', '1'), ('21', '2017-03-29 03:57:03.894449', '5', 'A-机房弱电井    1-机房断电', '1', '[{\"added\": {}}]', '12', '1'), ('22', '2017-03-29 03:57:15.490782', '6', 'A-机房弱电井    2-机房UPS故障', '1', '[{\"added\": {}}]', '12', '1'), ('23', '2017-03-29 03:57:24.609333', '7', 'A-机房弱电井    3-机房空调故障', '1', '[{\"added\": {}}]', '12', '1'), ('24', '2017-03-29 03:57:34.580479', '8', 'B-租机商户    1-POS机宕机重装系统', '1', '[{\"added\": {}}]', '12', '1'), ('25', '2017-03-29 03:57:42.308543', '9', 'B-租机商户    2-POS机宕机修复系统', '1', '[{\"added\": {}}]', '12', '1'), ('26', '2017-03-29 03:57:50.401248', '10', 'C-数据接口商户    1-商户忘记上传数据', '1', '[{\"added\": {}}]', '12', '1'), ('27', '2017-03-29 03:57:59.259014', '11', 'D-办公室PC    1-Windows故障重装系统', '1', '[{\"added\": {}}]', '12', '1'), ('28', '2017-03-29 03:58:08.201268', '12', 'D-办公室PC    2-Windows故障修复系统', '1', '[{\"added\": {}}]', '12', '1'), ('29', '2017-03-29 03:58:16.018028', '13', 'E-应用系统    1-EIP', '1', '[{\"added\": {}}]', '12', '1'), ('30', '2017-03-29 03:58:24.271118', '14', 'E-应用系统    2-商业ERP', '1', '[{\"added\": {}}]', '12', '1'), ('31', '2017-03-29 03:59:09.299514', '15', 'F-客服台    1-Mac故障重装系统', '1', '[{\"added\": {}}]', '12', '1'), ('32', '2017-03-29 03:59:17.390411', '16', 'F-客服台    2-Mac故障修复系统', '1', '[{\"added\": {}}]', '12', '1'), ('33', '2017-03-29 04:00:15.435772', '17', 'C-数据接口商户    2-Webservice服务端挂', '1', '[{\"added\": {}}]', '12', '1'), ('34', '2017-03-29 04:00:29.581678', '3', 'ICO,liunabin', '2', '[]', '7', '1'), ('35', '2017-03-29 04:00:37.174723', '3', 'iCO,liunabin', '2', '[{\"changed\": {\"fields\": [\"shopname\"]}}]', '7', '1'), ('36', '2017-03-29 08:12:26.472861', '18', 'A-机房弱电井    4-机房服务器硬盘故障', '1', '[{\"added\": {}}]', '12', '1'), ('37', '2017-03-29 08:12:39.634739', '19', 'A-机房弱电井    5-机房服务器其他故障', '1', '[{\"added\": {}}]', '12', '1'), ('38', '2017-03-29 08:12:46.902160', '20', 'A-机房弱电井    6-机房照明故障', '1', '[{\"added\": {}}]', '12', '1'), ('39', '2017-03-29 08:12:53.239062', '21', 'A-机房弱电井    7-机房网络设备故障', '1', '[{\"added\": {}}]', '12', '1'), ('40', '2017-03-29 08:13:00.625399', '22', 'A-机房弱电井    8-机房运营商出口故障', '1', '[{\"added\": {}}]', '12', '1'), ('41', '2017-03-29 08:13:07.757800', '23', 'A-机房弱电井    9-机房其他故障', '1', '[{\"added\": {}}]', '12', '1'), ('42', '2017-03-29 08:13:14.359786', '24', 'A-机房弱电井    10-电井断电', '1', '[{\"added\": {}}]', '12', '1'), ('43', '2017-03-29 08:13:20.719111', '25', 'A-机房弱电井    11-电井综合布线故障', '1', '[{\"added\": {}}]', '12', '1'), ('44', '2017-03-29 08:13:26.329468', '26', 'A-机房弱电井    12-电井交换机故障', '1', '[{\"added\": {}}]', '12', '1'), ('45', '2017-03-29 08:22:25.367108', '27', 'B-租机商户    3-POS机断网', '1', '[{\"added\": {}}]', '12', '1'), ('46', '2017-03-29 08:34:26.895342', '28', 'B-租机商户    4-POS机数据库故障', '1', '[{\"added\": {}}]', '12', '1'), ('47', '2017-03-29 08:34:32.630558', '29', 'B-租机商户    5-POS机主机硬件故障', '1', '[{\"added\": {}}]', '12', '1'), ('48', '2017-03-29 08:34:37.858563', '30', 'B-租机商户    6-打印机故障', '1', '[{\"added\": {}}]', '12', '1'), ('49', '2017-03-29 08:34:44.568822', '31', 'B-租机商户    7-扫码枪故障', '1', '[{\"added\": {}}]', '12', '1'), ('50', '2017-03-29 08:34:50.477059', '32', 'B-租机商户    8-刷卡机故障', '1', '[{\"added\": {}}]', '12', '1'), ('51', '2017-03-29 08:34:55.895151', '33', 'B-租机商户    9-TTPOS故障', '1', '[{\"added\": {}}]', '12', '1'), ('52', '2017-03-29 08:35:01.720002', '34', 'B-租机商户    10-科传前台故障', '1', '[{\"added\": {}}]', '12', '1'), ('53', '2017-03-29 08:35:07.503608', '35', 'B-租机商户    11-其他故障', '1', '[{\"added\": {}}]', '12', '1'), ('54', '2017-03-29 08:35:43.737069', '36', 'C-数据接口商户    2-Webservice服务端挂', '1', '[{\"added\": {}}]', '12', '1'), ('55', '2017-03-29 08:35:49.976385', '37', 'C-数据接口商户    3-商户开发Webservice协助', '1', '[{\"added\": {}}]', '12', '1'), ('56', '2017-03-29 08:36:31.308242', '38', 'D-办公室PC    3-Office系列故障', '1', '[{\"added\": {}}]', '12', '1'), ('57', '2017-03-29 08:36:39.811904', '39', 'D-办公室PC    4-常用软件安装', '1', '[{\"added\": {}}]', '12', '1'), ('58', '2017-03-29 08:36:48.639719', '40', 'D-办公室PC    5-浏览器故障', '1', '[{\"added\": {}}]', '12', '1'), ('59', '2017-03-29 08:36:59.188716', '41', 'D-办公室PC    6-视频会议调试', '1', '[{\"added\": {}}]', '12', '1'), ('60', '2017-03-29 08:37:04.831483', '42', 'D-办公室PC    7-培训室音箱调试', '1', '[{\"added\": {}}]', '12', '1'), ('61', '2017-03-29 08:37:11.039472', '43', 'D-办公室PC    8-办公PC中毒', '1', '[{\"added\": {}}]', '12', '1'), ('62', '2017-03-29 08:37:21.306191', '44', 'D-办公室PC    9-办公室友情协助', '1', '[{\"added\": {}}]', '12', '1'), ('63', '2017-03-29 08:38:18.978307', '45', 'E-应用系统    3-采招ERP故障', '1', '[{\"added\": {}}]', '12', '1'), ('64', '2017-03-29 08:38:24.249490', '46', 'E-应用系统    4-ESPOS故障', '1', '[{\"added\": {}}]', '12', '1'), ('65', '2017-03-29 08:38:29.464477', '47', 'E-应用系统    5-BI故障', '1', '[{\"added\": {}}]', '12', '1'), ('66', '2017-03-29 08:38:43.873236', '48', 'F-客服台    3-小票打印机故障', '1', '[{\"added\": {}}]', '12', '1'), ('67', '2017-03-29 08:38:49.386135', '49', 'F-客服台    4-ESPOS积分故障', '1', '[{\"added\": {}}]', '12', '1'), ('68', '2017-03-29 08:38:55.441154', '50', 'F-客服台    5-背景音乐故障', '1', '[{\"added\": {}}]', '12', '1'), ('69', '2017-03-29 08:39:01.193185', '51', 'F-客服台    6-座机电话故障', '1', '[{\"added\": {}}]', '12', '1'), ('70', '2017-03-29 08:39:07.128612', '52', 'F-客服台    7-客服台友情协助', '1', '[{\"added\": {}}]', '12', '1'), ('71', '2017-03-29 08:42:18.222410', '68', 'E-应用系统    1-EIP故障', '2', '[{\"changed\": {\"fields\": [\"comment\"]}}]', '13', '1'), ('72', '2017-03-31 13:07:36.346368', '4', 'chenting', '1', '[{\"added\": {}}]', '3', '1'), ('73', '2017-03-31 13:07:47.236588', '5', 'linyuan', '1', '[{\"added\": {}}]', '3', '1'), ('74', '2017-03-31 13:08:00.818272', '6', 'dengwenxian', '1', '[{\"added\": {}}]', '3', '1'), ('75', '2017-03-31 13:08:34.602580', '7', 'zhudong', '1', '[{\"added\": {}}]', '3', '1'), ('76', '2017-03-31 13:09:01.165786', '8', 'wufujing', '1', '[{\"added\": {}}]', '3', '1'), ('77', '2017-03-31 13:09:12.926558', '9', 'yuanruoqing', '1', '[{\"added\": {}}]', '3', '1'), ('78', '2017-03-31 13:09:43.289271', '10', 'leixiaoming', '1', '[{\"added\": {}}]', '3', '1'), ('79', '2017-03-31 13:11:11.821202', '1', '龙华COCO City', '1', '[{\"added\": {}}]', '4', '1'), ('80', '2017-03-31 13:11:27.378245', '2', '福田COCO Park', '1', '[{\"added\": {}}]', '4', '1'), ('81', '2017-03-31 13:11:35.469204', '3', '龙岗COCO Park', '1', '[{\"added\": {}}]', '4', '1'), ('82', '2017-03-31 13:11:45.413828', '4', '龙华iCO', '1', '[{\"added\": {}}]', '4', '1'), ('83', '2017-03-31 13:11:53.517948', '5', '常州COCO City', '1', '[{\"added\": {}}]', '4', '1'), ('84', '2017-03-31 13:12:10.313479', '6', '普宁COCO City', '1', '[{\"added\": {}}]', '4', '1'), ('85', '2017-03-31 13:15:22.966853', '3', 'wangzi', '3', '', '3', '1'), ('86', '2017-03-31 13:15:47.058778', '11', 'zhoubinbin', '1', '[{\"added\": {}}]', '3', '1'), ('87', '2017-03-31 13:15:59.575572', '12', 'lujun', '1', '[{\"added\": {}}]', '3', '1'), ('88', '2017-03-31 13:17:14.658955', '5', '常州COCO City', '3', '', '4', '1'), ('89', '2017-03-31 13:17:14.664422', '6', '普宁COCO City', '3', '', '4', '1'), ('90', '2017-03-31 13:17:14.668969', '2', '福田COCO Park', '3', '', '4', '1'), ('91', '2017-03-31 13:17:14.673578', '1', '龙华COCO City', '3', '', '4', '1'), ('92', '2017-03-31 13:17:14.678061', '4', '龙华iCO', '3', '', '4', '1'), ('93', '2017-03-31 13:17:14.682874', '3', '龙岗COCO Park', '3', '', '4', '1'), ('94', '2017-03-31 13:17:28.667449', '3', '和收银姑娘聊天', '3', '', '9', '1'), ('95', '2017-03-31 13:17:28.672695', '2', '回收POS机', '3', '', '9', '1'), ('96', '2017-03-31 13:17:28.677194', '1', '和收银员聊天', '3', '', '9', '1'), ('97', '2017-03-31 13:17:36.414180', '2', 'POS系统', '3', '', '10', '1'), ('98', '2017-03-31 13:17:36.419281', '1', '收银系统', '3', '', '10', '1'), ('99', '2017-03-31 13:17:57.812209', '3', 'iCO,liunabin', '3', '', '7', '1'), ('100', '2017-03-31 13:17:57.818480', '2', 'cococity,wangzi', '3', '', '7', '1'), ('101', '2017-03-31 13:17:57.822935', '1', 'cococity,liunabin', '3', '', '7', '1'), ('102', '2017-03-31 13:20:29.496449', '4', 'chenting', '2', '[{\"changed\": {\"fields\": [\"is_staff\", \"last_login\"]}}]', '3', '1'), ('103', '2017-03-31 13:22:08.139234', '4', 'chenting', '2', '[{\"changed\": {\"fields\": [\"is_staff\", \"last_login\"]}}]', '3', '1'), ('104', '2017-03-31 13:26:33.274836', '13', 'caizhibin', '1', '[{\"added\": {}}]', '3', '1'), ('105', '2017-03-31 13:27:03.252228', '14', 'zhongzhenhong', '1', '[{\"added\": {}}]', '3', '1'), ('106', '2017-03-31 13:31:02.291528', '15', 'mailicheng', '1', '[{\"added\": {}}]', '3', '1'), ('107', '2017-03-31 13:31:57.057585', '110', 'H-WIFI系统    2-出口宽带故障', '1', '[{\"added\": {}}]', '12', '1'), ('108', '2017-03-31 14:05:29.316448', '16', 'test', '1', '[{\"added\": {}}]', '3', '1');
COMMIT;

-- ----------------------------
--  Table structure for `django_content_type`
-- ----------------------------
DROP TABLE IF EXISTS `django_content_type`;
CREATE TABLE `django_content_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `django_content_type`
-- ----------------------------
BEGIN;
INSERT INTO `django_content_type` VALUES ('1', 'admin', 'logentry'), ('4', 'auth', 'group'), ('2', 'auth', 'permission'), ('3', 'auth', 'user'), ('5', 'contenttypes', 'contenttype'), ('6', 'sessions', 'session'), ('12', 'work', 'config'), ('9', 'work', 'error'), ('11', 'work', 'record'), ('7', 'work', 'shop'), ('10', 'work', 'system'), ('13', 'work', 'workrecord');
COMMIT;

-- ----------------------------
--  Table structure for `django_migrations`
-- ----------------------------
DROP TABLE IF EXISTS `django_migrations`;
CREATE TABLE `django_migrations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `django_migrations`
-- ----------------------------
BEGIN;
INSERT INTO `django_migrations` VALUES ('1', 'contenttypes', '0001_initial', '2017-03-28 04:22:19.332630'), ('2', 'auth', '0001_initial', '2017-03-28 04:22:22.696039'), ('3', 'admin', '0001_initial', '2017-03-28 04:22:23.931829'), ('4', 'admin', '0002_logentry_remove_auto_add', '2017-03-28 04:22:24.484831'), ('5', 'contenttypes', '0002_remove_content_type_name', '2017-03-28 04:22:24.939296'), ('6', 'auth', '0002_alter_permission_name_max_length', '2017-03-28 04:22:25.374644'), ('7', 'auth', '0003_alter_user_email_max_length', '2017-03-28 04:22:25.541861'), ('8', 'auth', '0004_alter_user_username_opts', '2017-03-28 04:22:25.858109'), ('9', 'auth', '0005_alter_user_last_login_null', '2017-03-28 04:22:27.203621'), ('10', 'auth', '0006_require_contenttypes_0002', '2017-03-28 04:22:27.257748'), ('11', 'auth', '0007_alter_validators_add_error_messages', '2017-03-28 04:22:27.324162'), ('12', 'auth', '0008_alter_user_username_max_length', '2017-03-28 04:22:27.491994'), ('13', 'sessions', '0001_initial', '2017-03-28 04:22:28.115559'), ('14', 'work', '0001_initial', '2017-03-28 04:22:28.978246'), ('15', 'work', '0002_shop_worker', '2017-03-28 07:52:42.364423'), ('16', 'work', '0003_auto_20170328_1557', '2017-03-28 07:57:15.661011'), ('17', 'work', '0004_remove_work_shop', '2017-03-28 07:59:23.752339'), ('18', 'work', '0005_auto_20170328_1622', '2017-03-28 08:23:04.885125'), ('19', 'work', '0006_auto_20170328_1634', '2017-03-28 08:34:50.519021'), ('20', 'work', '0007_record', '2017-03-28 10:28:26.662921'), ('21', 'work', '0008_auto_20170328_1835', '2017-03-28 10:36:04.566196'), ('22', 'work', '0009_config', '2017-03-28 12:12:21.374047'), ('23', 'work', '0010_auto_20170329_0916', '2017-03-29 01:16:17.080973'), ('24', 'work', '0011_workrecord', '2017-03-29 05:54:39.292497');
COMMIT;

-- ----------------------------
--  Table structure for `django_session`
-- ----------------------------
DROP TABLE IF EXISTS `django_session`;
CREATE TABLE `django_session` (
  `session_key` varchar(40) NOT NULL,
  `session_data` longtext NOT NULL,
  `expire_date` datetime(6) NOT NULL,
  PRIMARY KEY (`session_key`),
  KEY `django_session_de54fa62` (`expire_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `django_session`
-- ----------------------------
BEGIN;
INSERT INTO `django_session` VALUES ('3uq31l9ml798s76pbl0ij54vzfdh1e70', 'ZjNkYzMyZTU0YzQ2YzNkMjA2ZGJhMjI0NGQ1MGRkOTg3NDk1NjE2OTp7Il9hdXRoX3VzZXJfaGFzaCI6ImQ5OGM4NGFkNTUwMDQ3NjUwZDBiNGEyODk5ZjI1OTc1MjBjOTljNmUiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiI0IiwidXNlciI6ImNoZW50aW5nIn0=', '2017-04-14 13:28:26.813245'), ('9gr5ggkl4lza4b37uuvklnail3hl63hq', 'NmE0M2UyMDU5ZjhlM2I0NTNkNWM0ZWI1OGQ4NTE4YWIwMTcyOTA0ZDp7Il9hdXRoX3VzZXJfaGFzaCI6IjdlZGY0Y2Q5OTYzZDY4MTI5ODRiZGJjNTIzZjg1YjZlN2RmYWNjYTciLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiIyIiwidXNlciI6ImxpdW5hYmluIn0=', '2017-04-15 02:58:35.165274'), ('a1ef5y16f882ctiy10ckjpwld1dgx97y', 'NmE0M2UyMDU5ZjhlM2I0NTNkNWM0ZWI1OGQ4NTE4YWIwMTcyOTA0ZDp7Il9hdXRoX3VzZXJfaGFzaCI6IjdlZGY0Y2Q5OTYzZDY4MTI5ODRiZGJjNTIzZjg1YjZlN2RmYWNjYTciLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiIyIiwidXNlciI6ImxpdW5hYmluIn0=', '2017-04-12 07:57:00.251391'), ('b8g2mpruz02fg3kigdge5hrybxhji0po', 'ZDM2OTQxM2Q1MjFiNjE3NjJiMzZhMWU4YWNkZWQ4MjM3NDhjODNiYTp7Il9hdXRoX3VzZXJfaGFzaCI6ImYyYWZmMmM2NzFlODg1NTEzYmMzOTJhMDI2OWQyNmE1YmUwMGMwOTAiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiIxNiIsInVzZXIiOiJ0ZXN0In0=', '2017-04-14 14:15:44.588413'), ('bgavb8kzku0pdg95cx00312ln05nxyp0', 'NmE0M2UyMDU5ZjhlM2I0NTNkNWM0ZWI1OGQ4NTE4YWIwMTcyOTA0ZDp7Il9hdXRoX3VzZXJfaGFzaCI6IjdlZGY0Y2Q5OTYzZDY4MTI5ODRiZGJjNTIzZjg1YjZlN2RmYWNjYTciLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiIyIiwidXNlciI6ImxpdW5hYmluIn0=', '2017-04-11 09:04:53.064283'), ('f7r2e8dlz3qw2kd1hv3nhk42qbetzslm', 'ZjNkYzMyZTU0YzQ2YzNkMjA2ZGJhMjI0NGQ1MGRkOTg3NDk1NjE2OTp7Il9hdXRoX3VzZXJfaGFzaCI6ImQ5OGM4NGFkNTUwMDQ3NjUwZDBiNGEyODk5ZjI1OTc1MjBjOTljNmUiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiI0IiwidXNlciI6ImNoZW50aW5nIn0=', '2017-04-14 13:25:26.039863'), ('gceuc1ozqq4d4xmw0ow82a63hv542u9g', 'ZDM2OTQxM2Q1MjFiNjE3NjJiMzZhMWU4YWNkZWQ4MjM3NDhjODNiYTp7Il9hdXRoX3VzZXJfaGFzaCI6ImYyYWZmMmM2NzFlODg1NTEzYmMzOTJhMDI2OWQyNmE1YmUwMGMwOTAiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiIxNiIsInVzZXIiOiJ0ZXN0In0=', '2017-04-14 14:06:03.332752'), ('h9cm6t8e6pzx6i6wihq83elhakmg86bw', 'NmE0M2UyMDU5ZjhlM2I0NTNkNWM0ZWI1OGQ4NTE4YWIwMTcyOTA0ZDp7Il9hdXRoX3VzZXJfaGFzaCI6IjdlZGY0Y2Q5OTYzZDY4MTI5ODRiZGJjNTIzZjg1YjZlN2RmYWNjYTciLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiIyIiwidXNlciI6ImxpdW5hYmluIn0=', '2017-04-14 02:41:46.186937'), ('jq3qeb7h8rrna125kiaho3r56xauqk8h', 'NmE0M2UyMDU5ZjhlM2I0NTNkNWM0ZWI1OGQ4NTE4YWIwMTcyOTA0ZDp7Il9hdXRoX3VzZXJfaGFzaCI6IjdlZGY0Y2Q5OTYzZDY4MTI5ODRiZGJjNTIzZjg1YjZlN2RmYWNjYTciLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiIyIiwidXNlciI6ImxpdW5hYmluIn0=', '2017-04-11 14:17:08.950450'), ('kqa5re0nuxos263avdbgicqiflmgz3cu', 'NmE0M2UyMDU5ZjhlM2I0NTNkNWM0ZWI1OGQ4NTE4YWIwMTcyOTA0ZDp7Il9hdXRoX3VzZXJfaGFzaCI6IjdlZGY0Y2Q5OTYzZDY4MTI5ODRiZGJjNTIzZjg1YjZlN2RmYWNjYTciLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiIyIiwidXNlciI6ImxpdW5hYmluIn0=', '2017-04-14 14:21:05.035645'), ('qd0sw17g3xp2c9yqyhu9no05i0q83f8n', 'ZmUzMGI0MzlmYTMzZGEyNjhjYTc2NmMwMWYzMGE2NDVlNTgxMzdiZTp7Il9hdXRoX3VzZXJfaGFzaCI6IjQxYTc5ZjAzZjRkNTRiMDMzMjBlODFiNThmY2FmYWExMTU4ODViMjUiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiIxIn0=', '2017-04-12 03:06:00.858316'), ('rr8vkmxi9hg254q8r9xigk9w3x7uqrye', 'MGIyODRmZjAzMTQ5ZWIzNmZlNWEwMmVmMzYzMWY5YjEwNTBiZTg2Nzp7Il9hdXRoX3VzZXJfaGFzaCI6ImFlZmQ2NTRlOTFhNWJmMjVjNWVjOWU3YWNhOTE3ODIyNWFmOThhZmQiLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiIzIiwidXNlciI6Indhbmd6aSJ9', '2017-04-14 03:20:05.929398'), ('s1c0sw262ce9qh8qr7bhgjvoqvnxmh1v', 'NmE0M2UyMDU5ZjhlM2I0NTNkNWM0ZWI1OGQ4NTE4YWIwMTcyOTA0ZDp7Il9hdXRoX3VzZXJfaGFzaCI6IjdlZGY0Y2Q5OTYzZDY4MTI5ODRiZGJjNTIzZjg1YjZlN2RmYWNjYTciLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiIyIiwidXNlciI6ImxpdW5hYmluIn0=', '2017-04-12 07:13:41.872504'), ('voaqfg373ilkdfe4gz13axm1q072pxns', 'NmE0M2UyMDU5ZjhlM2I0NTNkNWM0ZWI1OGQ4NTE4YWIwMTcyOTA0ZDp7Il9hdXRoX3VzZXJfaGFzaCI6IjdlZGY0Y2Q5OTYzZDY4MTI5ODRiZGJjNTIzZjg1YjZlN2RmYWNjYTciLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiIyIiwidXNlciI6ImxpdW5hYmluIn0=', '2017-04-12 04:01:34.741293'), ('xgayg47eg5isv5uyutq2qddfsfiosbvr', 'NmE0M2UyMDU5ZjhlM2I0NTNkNWM0ZWI1OGQ4NTE4YWIwMTcyOTA0ZDp7Il9hdXRoX3VzZXJfaGFzaCI6IjdlZGY0Y2Q5OTYzZDY4MTI5ODRiZGJjNTIzZjg1YjZlN2RmYWNjYTciLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiIyIiwidXNlciI6ImxpdW5hYmluIn0=', '2017-04-12 03:06:58.091101'), ('ygdo8b5cy3fyz9e51m364mkztmmp63gc', 'NmE0M2UyMDU5ZjhlM2I0NTNkNWM0ZWI1OGQ4NTE4YWIwMTcyOTA0ZDp7Il9hdXRoX3VzZXJfaGFzaCI6IjdlZGY0Y2Q5OTYzZDY4MTI5ODRiZGJjNTIzZjg1YjZlN2RmYWNjYTciLCJfYXV0aF91c2VyX2JhY2tlbmQiOiJkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZCIsIl9hdXRoX3VzZXJfaWQiOiIyIiwidXNlciI6ImxpdW5hYmluIn0=', '2017-04-12 08:47:23.593991');
COMMIT;

-- ----------------------------
--  Table structure for `work_config`
-- ----------------------------
DROP TABLE IF EXISTS `work_config`;
CREATE TABLE `work_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `comment` varchar(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `work_config`
-- ----------------------------
BEGIN;
INSERT INTO `work_config` VALUES ('54', '1-机房断电', 'A-机房弱电井'), ('55', '2-机房UPS故障', 'A-机房弱电井'), ('56', '3-机房空调故障', 'A-机房弱电井'), ('57', '4-机房服务器硬盘故障', 'A-机房弱电井'), ('58', '5-机房服务器其他故障', 'A-机房弱电井'), ('59', '6-机房照明故障', 'A-机房弱电井'), ('60', '7-机房网络设备故障', 'A-机房弱电井'), ('61', '8-机房运营商出口故障', 'A-机房弱电井'), ('62', '9-机房其他故障', 'A-机房弱电井'), ('63', '10-电井断电', 'A-机房弱电井'), ('64', '11-电井综合布线故障', 'A-机房弱电井'), ('65', '12-电井交换机故障', 'A-机房弱电井'), ('66', '1-POS机宕机重装系统', 'B-租机商户'), ('67', '2-POS机宕机修复系统', 'B-租机商户'), ('68', '3-POS机断网', 'B-租机商户'), ('69', '4-POS机数据库故障', 'B-租机商户'), ('70', '5-POS机主机硬件故障', 'B-租机商户'), ('71', '6-打印机故障', 'B-租机商户'), ('72', '7-扫码枪故障', 'B-租机商户'), ('73', '8-刷卡机故障', 'B-租机商户'), ('74', '9-TTPOS故障', 'B-租机商户'), ('75', '10-科传前台故障', 'B-租机商户'), ('76', '1-商户忘记上传数据', 'C-数据接口商户'), ('77', '2-Webservice服务端挂', 'C-数据接口商户'), ('78', '3-商户开发Webservice协助', 'C-数据接口商户'), ('79', '1-Windows故障重装系统', 'D-办公室PC'), ('80', '2-Windows故障修复系统', 'D-办公室PC'), ('81', '3-Office系列故障', 'D-办公室PC'), ('82', '4-常用软件安装', 'D-办公室PC'), ('83', '5-浏览器故障', 'D-办公室PC'), ('84', '6-视频会议调试', 'D-办公室PC'), ('85', '7-培训室音箱调试', 'D-办公室PC'), ('86', '8-办公PC中毒', 'D-办公室PC'), ('87', '9-办公室友情协助', 'D-办公室PC'), ('88', '1-EIP故障', 'E-应用系统'), ('89', '2-商业ERP故障', 'E-应用系统'), ('90', '3-采招ERP故障', 'E-应用系统'), ('91', '4-ESPOS故障', 'E-应用系统'), ('92', '5-BI故障', 'E-应用系统'), ('93', '1-Mac故障重装系统', 'F-客服台'), ('94', '2-Mac故障修复系统', 'F-客服台'), ('95', '3-小票打印机故障', 'F-客服台'), ('96', '4-ESPOS积分故障', 'F-客服台'), ('97', '5-背景音乐故障', 'F-客服台'), ('98', '6-座机电话故障', 'F-客服台'), ('99', '7-客服台友情协助', 'F-客服台'), ('100', '1-客流镜头没有上传数据', 'G-客流系统'), ('101', '1-AP掉线', 'H-WIFI系统'), ('102', '1-闸机故障', 'I-停车场系统'), ('103', '2-线上支付故障', 'I-停车场系统'), ('104', '1-信息发布机分辨率异常', 'G-信息发布系统'), ('105', '1-友情协助调试宽带', 'K-商户友情协助'), ('106', '2-友情协助安装系统', 'K-商户友情协助'), ('107', '3-友情协助安装软件', 'K-商户友情协助'), ('108', '4-友情协助修复系统', 'K-商户友情协助'), ('109', '1-COCO童堡背景音乐故障', 'L-其他'), ('110', '2-出口宽带故障', 'H-WIFI系统');
COMMIT;

-- ----------------------------
--  Table structure for `work_error`
-- ----------------------------
DROP TABLE IF EXISTS `work_error`;
CREATE TABLE `work_error` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `errortype` varchar(255) NOT NULL,
  `system_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `work_error_system_id_b03cadb3_fk_work_system_id` (`system_id`),
  CONSTRAINT `work_error_system_id_b03cadb3_fk_work_system_id` FOREIGN KEY (`system_id`) REFERENCES `work_system` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `work_record`
-- ----------------------------
DROP TABLE IF EXISTS `work_record`;
CREATE TABLE `work_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shopname` varchar(50) NOT NULL,
  `systemname` varchar(50) NOT NULL,
  `errortype` varchar(255) NOT NULL,
  `worker` varchar(50) NOT NULL,
  `flowtime` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=218 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `work_record`
-- ----------------------------
BEGIN;
INSERT INTO `work_record` VALUES ('37', 'cococity', '收银系统', '和收银员聊天', 'wangzi', '2017-03-28 20:00:12'), ('213', 'cococity', 'POS系统', '回收POS机', 'wangzi', '2017-03-29 12:01:10'), ('214', 'cococity', 'POS系统', '回收POS机', 'wangzi', '2017-03-29 12:01:10'), ('215', 'cococity', 'POS系统', '回收POS机', 'wangzi', '2017-03-29 12:01:11'), ('216', 'cococity', 'POS系统', '回收POS机', 'wangzi', '2017-03-29 12:01:11'), ('217', 'cococity', 'POS系统', '回收POS机', 'wangzi', '2017-03-29 12:01:11');
COMMIT;

-- ----------------------------
--  Table structure for `work_shop`
-- ----------------------------
DROP TABLE IF EXISTS `work_shop`;
CREATE TABLE `work_shop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shopname` varchar(50) NOT NULL,
  `worker` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `work_shop_shopname_9b9f5832_uniq` (`shopname`,`worker`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `work_system`
-- ----------------------------
DROP TABLE IF EXISTS `work_system`;
CREATE TABLE `work_system` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `systemname` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `work_workrecord`
-- ----------------------------
DROP TABLE IF EXISTS `work_workrecord`;
CREATE TABLE `work_workrecord` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `comment` varchar(255) NOT NULL,
  `mark` varchar(255) NOT NULL,
  `time` varchar(255) NOT NULL,
  `worker` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `work_workrecord`
-- ----------------------------
BEGIN;
INSERT INTO `work_workrecord` VALUES ('95', 'K-商户友情协助', '3-友情协助安装软件', '大多发生', '2017-03-29  中午', 'wangzi'), ('98', 'L-其他', '1-COCO童堡背景音乐故障', '', '2017-03-29  上午', 'liunabin'), ('99', 'L-其他', '1-COCO童堡背景音乐故障', '', '2017-03-29  上午', 'liunabin'), ('101', 'L-其他', '1-COCO童堡背景音乐故障', 'a', '2017-03-29  上午', 'liunabin'), ('102', 'L-其他', '1-COCO童堡背景音乐故障', '1', '2017-03-29  上午', 'wangzi'), ('103', 'A-机房弱电井', '1-机房断电', '', '2017-03-29  上午', 'liunabin'), ('105', 'K-商户友情协助', '2-友情协助安装系统', 'wzwzwz', '2017-03-29  晚上', 'wangzi'), ('106', 'K-商户友情协助', '1-友情协助调试宽带', 'aa', '2017-03-29  上午', 'wangzi'), ('107', 'K-商户友情协助', '1-友情协助调试宽带', 'aa', '2017-03-29  上午', 'wangzi'), ('108', 'K-商户友情协助', '2-友情协助安装系统', 'aa', '2017-03-29  上午', 'wangzi'), ('110', 'L-其他', '1-COCO童堡背景音乐故障', 'a', '2017-03-29  上午', 'wangzi'), ('115', 'K-商户友情协助', '3-友情协助安装软件', 'a', '2017-03-29  上午', 'wangzi'), ('116', 'A-机房弱电井', '1-机房断电', '', '2017-03-30  上午', 'liunabin'), ('117', 'C-数据接口商户', '2-Webservice服务端挂', '', '2017-03-30  上午', 'liunabin'), ('118', 'F-客服台', '6-座机电话故障', '1234', '2017-03-30  晚上', 'liunabin'), ('120', 'K-商户友情协助', '4-友情协助修复系统', '1', '2017-03-31  晚上', 'wangzi'), ('121', 'A-机房弱电井', '1-机房断电', 'COCO City断电', '2017-03-31  下午', 'chenting'), ('122', 'B-租机商户', '1-POS机宕机重装系统', 'COCO City', '2017-03-31  晚上', 'chenting'), ('123', 'E-应用系统', '2-商业ERP故障', 'iCO 项目', '2017-03-31  上午', 'chenting'), ('126', 'B-租机商户', '7-扫码枪故障', '', '2017-03-31  上午', 'liunabin');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
